Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Previous Next

Interesting

Obviously things like excessive deletion stubs and pre-existing database fragmentation are not an issue. But disk fragmentation could be an issue. The file is obviously going to start off very small and have to grow a lot, which means a lot of new disk allocations. You might want to see if your server disk is being defragged regularly, look into either DominoDefrag over on the OpenNTF site, or Defrag.NSF (commerical software from Preemptime), and/or create a "big empty NSF" and try importing into that.

I.e., on that latter point: create a new empty database and then fill it with a small number of very large documents. E.g., 10 documents with 100 MB of attachments in each one, to give you a 1 GB database. (Do this on a server that does not have DAOS, so the storage allocation is real.) Now delete the documents, and do not compact. You now have a big empty database. If you defrag your disk, you will have a big empty database occupying a large contiguous space on disk, and it won't have to grow during your import process so the writes will be about as fast as you can possibly get.

Of course, that's on top of other suggestions, but badly fragmented databases can have a pretty big impact on throughput, so if your code is already as optimized as it can get this would be a logical step.

-rich


Feedback response number WEBB95DQ4B created by ~Ned Nimfanakonyoopsi on 03/01/2013

Importing Files into Notes Database... (~Delores Asajip... 25.Feb.13)
. . Some suggestions. (~Cheryl Opfreet... 25.Feb.13)
. . . . Using COL files for importing (~Delores Asajip... 25.Feb.13)
. . . . . . COL Files. (~Cheryl Opfreet... 25.Feb.13)
. . Some ideas... (~Dan Kikiterobu... 25.Feb.13)
. . . . Yup, I agree with you (~Delores Asajip... 26.Feb.13)
. . Tell us more (~Ned Nimfanakon... 25.Feb.13)
. . . . Answers ...... (~Delores Asajip... 26.Feb.13)
. . . . . . Thoughts (~Ned Nimfanakon... 26.Feb.13)
. . . . . . One more question (~Ned Nimfanakon... 27.Feb.13)
. . . . . . . . Re: One more question (~Delores Asajip... 1.Mar.13)
. . . . . . . . . . Interesting (~Ned Nimfanakon... 1.Mar.13)
. . . . . . . . . . . . Unique (~Delores Asajip... 5.Mar.13)
. . Other things (~Sean Eljumigon... 25.Feb.13)
. . . . Code .. not possible (~Delores Asajip... 26.Feb.13)
. . . . . . Code... (~Dan Kikiterobu... 26.Feb.13)
. . Post the code... (~Dan Kikiterobu... 25.Feb.13)
. . a few more :-) (~Tony Opluterle... 25.Feb.13)
. . . . Re: a few more (~Delores Asajip... 26.Feb.13)
. . . . . . Cache lookups (~Dan Kikiterobu... 26.Feb.13)
. . . . . . Delete doc ; releases document from... (~Tony Opluterle... 27.Feb.13)
. . . . . . . . Re: Delete doc (~Delores Asajip... 1.Mar.13)
. . You might want to try... (~Judy Ektumizen... 27.Feb.13)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS